﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DeltaFlex.Data
{
    public static class ConsProcedures
    {
        #region Articles
        public class Articles
        {
            public const string SP_INSERTAR_ARTICLE = "sp_InsertarArticle";
            public const string PARAMETRE_REFERENCIA = "REFERENCIAARTICLE";
            public const string PARAMETRE_NOM = "NOMARTICLE";
            public const string PARAMETRE_UNITAT = "UNITAT";
            public const string PARAMETRE_PVP = "PVP";
            
            public const string SP_CERCART_TOTS_ARTICLES = "sp_CercarTotsArticles";

            public const string SP_CERCAR_ARTICLE_BY_IDARTICLE = "sp_CercarArticleByIdArticle";
            public const string PARAMETRE_IDARTICLE = "@IDARTICLE";

        }
        #endregion

        #region Client
        public class Client
        {
            public const string SP_INSERTARCLIENT = "sp_InsertarClient";

            public const string PARAMETRE_NOMCLIENT = "@NOMCLIENT";
            public const string PARAMETRE_NIFCLIENT = "@NIFCLIENT";
            public const string PARAMETRE_IDADREÇACLIENT = "@IDADREÇACLIENT";
            public const string PARAMETRE_TELEFONCLIENT = "@TELEFONCLIENT";
            public const string PARAMETRE_FAXCLIENT = "@FAXCLIENT";
            public const string PARAMETRE_EMAIL = "@EMAIL";
            public const string PARAMETRE_NUMCOMPTE = "@NUMCOMPTE";
            public const string PARAMETRE_FORMAPAGO = "@FORMAPAGO";

            public const string PARAMETRE_CARRERNUMERO = "@CARRERNUMERO";
            public const string PARAMETRE_POLIGON = "@POLIGON";
            public const string PARAMETRE_CIUTAT = "@CIUTAT";
            public const string PARAMETRE_CODIPOSTAL = "@CODIPOSTAL";
            public const string PARAMETRE_PROVINCIA = "@PROVINCIA";
            public const string PARAMETRE_PAIS = "@PAIS";

            public const string SP_CERCAR_CLIENT_BY_IDCLIENT = "sp_CercarClientByIDClient";
            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";
        }

        public class AdreçaClient
        {
            public const string SP_INSERTARADREÇACLIENT = "sp_InsertarAdreçaClient";

            public const string PARAMETRE_CARRERNUMERO = "@CARRERNUMERO";
            public const string PARAMETRE_POLIGON = "@POLIGON";
            public const string PARAMETRE_CIUTAT = "@CIUTAT";
            public const string PARAMETRE_CODIPOSTAL = "@CODIPOSTAL";
            public const string PARAMETRE_PROVINCIA = "@PROVINCIA";
            public const string PARAMETRE_PAIS = "@PAIS";
        }

        #endregion

        #region Concepte 
        public class Concepte_OT
        {
            public const string SP_INSERTAR_CONCEPTE_OT = "sp_InsertarConcepte_OT";
            public const string PARAMETRE_IDORDRE = "@IDORDRE";
            public const string PARAMETRE_QUANTITAT = "@QUANTITAT";
            public const string PARAMETRE_ARTICLE = "@IDARTICLE";
            public const string PARAMETRE_AMPLE = "@AMPLE";
            public const string PARAMETRE_ALT = "@ALT";
            public const string PARAMETRE_IMPORT = "@IMPORT";

            public const string SP_CERCAR_CONCEPTE_OT_BY_IDORDRE = "sp_CercarConcepte_OTByIdOrdre";

            public const string SP_ACTUALITZARCONCEPTE_OT = "sp_ActualitzarConcepte_OT";
            public const string PARAMETRE_IDCONCEPTE = "@IDCONCEPTE";
        }

        public class Concepte_Albara
        {
            public const string SP_INSERTARCONCEPTE_ALBARA = "sp_InsertarConcepte_Albara";
            public const string PARAMETE_IDALBARA = "@IDALBARA";
            public const string PARAMETE_IDARTICLE = "@IDARTICLE";
            public const string PARAMETE_QUANTITAT = "@QUANTITAT";
            public const string PARAMETE_STRSUPERFICIE = "@STRSUPERFICIE";
            public const string PARAMETE_DECIMALSUPERFICIE = "@DECIMALSUPERFICIE";
            public const string PARAMETE_UNITATS = "@UNITATS";
            public const string PARAMETE_PVP = "@PVP";
            public const string PARAMETE_IMPORT = "@IMPORT";

            public const string SP_ACTUALITZAR_CONCEPTE_ALBARA = "sp_ActualitzarConcepte_Albara";
            public const string PARAMETRE_IDCONCEPTE_ALBARA = "@IDCONCEPTE_ALBARA";

            public const string SP_CERCARCONCEPTE_ALBARABYIDALBARA = "sp_CercarConcepte_AlbaraByIdAlbara";
        }

        public class Concepte_Factura
        {
            public const string SP_INSERTARCONCEPTE_FACTURA = "sp_InsertarConcepte_Factura";
            public const string PARAMETE_IDCONCEPTE_FACTURA = "@IDCONCEPTE_FACTURA";
            public const string PARAMETE_IDFACTURA = "@IDFACTURA";
            public const string PARAMETE_IDALBARA="@IDALBARA";
        }

        #endregion

        #region Maquina Cartoner
        public class MaquinaCartoner
        {
            public const string SP_CERCAR_MAQUINA_BY_IDCLIENT = "sp_CercarMaquinaByIdClient";
            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";

            public const string SP_CERCAR_MAQUINA_BY_IDMAQUINA = "sp_CercarMaquinaByIDMaquina";
            public const string PARAMETRE_IDMAQUINA = "@IDMAQUINA";

            public const string SP_INSERTAR_MAQUINA_CARTONER = "sp_InsertarMaquinaCartoner";
            public const string PARAMETRE_IDCLIENTIMPRESOR = "@IDCLIENTIMPRESOR";
            public const string PARAMETRE_NOMMAQUINA = "@NOMMAQUINA";
            public const string PARAMETRE_DEFLACCIOMAQUINA = "@DEFLACCIOMAQUINA";
            public const string PARAMETRE_CALIBREMAQUINA = "@CALIBREMAQUINA";
            public const string PARAMETRE_URLFITXAMAQUINA = "@URLFITXAMAQUINA";
                            


        }
        #endregion

        #region Ordre
        public class Ordre_Treball
        {
            public const string SP_INSERTAR_ORDRE_TREBALL = "sp_InsertarOrdre_Treball";
            public const string PARAMETRE_IDORDRE = "@IDORDRE";
            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";
            public const string PARAMETRE_IDIMPRESOR  = "@IDIMPRESOR ";
            public const string PARAMETRE_DATAENTREGA = "@DATAENTREGA";
            public const string PARAMETRE_HORAENTREGA = "@HORAENTREGA";
            public const string PARAMETRE_REFERENCIACLIENT = "@REFERENCIACLIENT";
            public const string PARAMETRE_IDTREBALL = "@IDTREBALL";
            public const string PARAMETRE_PEDIDOCLIENT = "@PEDIDOCLIENT";
            public const string PARAMETRE_TIPOTREBALL = "TIPOTREBALL";
            public const string PARAMETRE_TIPOCAIXA = "@TIPOCAIXA";
            public const string PARAMETRE_FITXA = "@FITXA";
            public const string PARAMETRE_TIPOMESURES = "@TIPOMESURES";
            public const string PARAMETRE_MESURES = "@MESURES";
            public const string PARAMETRE_NUMTROQUEL = "@NUMTROQUEL";
            public const string PARAMETRE_POSES = "@POSES";
            public const string PARAMETRE_MATERIALADJUNT = "@MATERIALADJUNT";
            public const string PARAMETRE_MATERIALTORNAR = "@MATERIALTORNAR";
            public const string PARAMETRE_COLORS = "@COLORS";
            public const string PARAMETRE_TIPOCLITXE = "@TIPOCLITXE";
            public const string PARAMETRE_IDMAQUINA = "@IDMAQUINA";
            public const string PARAMETRE_DEFLACCIO = "@DEFLACCIO";
            public const string PARAMETRE_FEINAFER = "@FEINAFER";
            public const string PARAMETRE_IDCONCEPTE = "@IDCONCEPTE";
            public const string PARAMETRE_OBSERVACIONS = "@OBSERVACIONS";
            public const string PARAMETRE_NOMARXIU = "@NOMARXIU";

            public const string SP_CERCAR_NEXT_IDORDRETREBALL = "sp_CercarNextIdOrdreTreball";

            public const string SP_CERCAROTBYIDOT = "sp_CercarOTByIdOT";

            public const string SP_CERCAR_ORDRE_TREBALL = "sp_CercarOrdreTreball";

            public const string SP_ACTUALITZARORDRE_TREBALL = "sp_ActualitzarOrdre_Treball";
                                            
        }
        #endregion

        #region Tipus Caixa
        public class TipusCaixa 
        {
            public const string SP_CERCAR_TOT_TIPUS_CAIXA = "sp_CercarTotTipusCaixa";
            
        }
        #endregion

        #region Tipus Treball
        public class TipusTreball
        {
            public const string SP_CERCAR_TOT_TIPUS_TREBALL = "sp_CercarTotTipusTreball";
        }
        #endregion

        #region Usuari 
        public class Usuari 
        {
            public const string SP_CERCAR_ROL_USUARI_BY_DNI = "sp_CercarRolUsuariByDNI";
            public const string PARAMETRE_DNIUSUARI = "@DNIUSUARI";

            public const string SP_ACTUALITZAR_DARRER_ACCES_USUARI = "sp_ActualitzarDarrerAccesUsuari";
            public const string PARAMETRE_IDUSUARI = "@IDUSUARI";
        }
        #endregion

        #region Albara
        public class Albara
        {
            public const string SP_INSERTAR_ALBARA = "sp_InsertarAlbara";
            public const string PARAMETRE_IDALBARA = "@IDALBARA";
            public const string PARAMETRE_IDORDRE_TREBALL = "@IDORDRE";
            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";
            public const string PARAMETRE_TOTAL = "@TOTAL";

            public const string SP_CERCAR_NEXT_IDALBARA = "sp_CercarNextIdAlbara";

            public const string SP_CERCAR_ALBARANS = "sp_CercarAlbarans";
            public const string PARAMETRE_DATAINICI = "@DATAINICI";
            public const string PARAMETRE_DATAFI = "@DATAFI";

            public const string SP_CERCAR_ALBARANS_BYIDALBARA = "sp_CercarAlbaransByIdAlbara";

            public const string SP_ACTUALITZAR_ALBARA = "sp_ActualitzarAlbara";
            public const string PARAMETRE_PEDIDOCLIENT = "@PEDIDOCLIENT";
            public const string PARAMETRE_REFERENCIACLIENT = "@REFERENCIACLIENT";
            public const string PARAMETRE_IDTREBALL = "@IDTREBALL";
            public const string PARAMETRE_NUMTROQUEL = "@NUMTROQUEL";
            public const string PARAMETRE_DATA = "@DATA";
        }
        
        #endregion

        #region Factura
        public class Factura
        {
            public const string SP_CERCAR_NEXT_IDFACTURA = "sp_CercarNextIdFactura";

            public const string SP_INSERTAR_FACTURA = "sp_InsertarFactura";
            public const string PARAMETRE_IDFACTURA = "@IDFACTURA";
            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";
            public const string PARAMETRE_DATA = "@DATA";
            public const string PARAMETRE_VENCIMENT ="@VENCIMENT";
            public const string PARAMETRE_TOTAL = "@TOTAL";
            
        }
        #endregion

        #region ClientArticlePreu
        public class ClientArticlePreu
        {
            public const string SP_INSERTAR_CLIENT_ARTICLE_PREU = "sp_InsertarClientArticlePreu";
            public const string SP_CERCAR_CLIENT_ARTICLE_PREU = "sp_CercarClientArticlePreu";

            public const string PARAMETRE_IDCLIENT = "@IDCLIENT";
            public const string PARAMETRE_IDARTICLE = "@IDARTICLE";
            public const string PARAMETRE_PREU = "@PREU";
        }
        #endregion

        

        #region
        #endregion

        #region
        #endregion

    }
}

